MyDAC

TCustomMyConnection.ExecSQL Method

Executes any SQL statement outside TMyQuery or TMyCommand components.

Class

TCustomMyConnection

Syntax

function ExecSQL(const Text: string; const Params: array of variant): variant; override;

Parameters
Text
Holds the SQL statement.
Params
Holds the array of the parameters values arranged in the same order as they appear in the SQL statement.
Return Value
Null.

Remarks

Call the ExecSQL method to execute any SQL statement outside TMyQuery or TMyCommand components. Supply the Params array with values of parameters arranged in the same order as they appear in SQL statement that is passed in Text string parameter.

Note: If a query doesn't have parameters (Params.Count = 0), this query will be executed faster.

© 1997-2024 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback